"192.168.0.1:sipop"

REQUISICION_BI

Descriptions

There is no desription for trigger REQUISICION_BI

Definition

CREATE TRIGGER REQUISICION_BI FOR REQUISICION ACTIVE
BEFORE INSERT POSITION 0
AS
declare variable HIJO integer;

BEGIN
  /* Trigger body */
  
IF (NEW.id_requisicion IS NULL) then
BEGIN
       HIJO = GEN_ID(gen_requisicion,1);
  new.id_requisicion=HIJO;
  NEW.datetime_insert='NOW';
  IF ( HIJO >99999999) THEN
     EXECUTE STATEMENT 'SET GENERATOR gen_requisicion TO 0';
   new.ANULADO ='false';
   new.ENTREGADO ='false';
 END
END

This file was generated with EMS InterBase/FireBird Manager (www.ibmanager.com) at 09/06/2005 05:52 p.m.